Capacity Scheduling Tables

Capacity Scheduling is available for Traverse Global only.

Column Name Column Type Length Default Value Description Enumeration
Id bigint        
HeaderId bigint        
DtlType tinyint       0 = Default, 1 = Queue, 2 = Machine Setup, 3 = Machine Run, 4 = Labor Setup, 5 = Labor Run, 6 = Wait, 7 = Move, 8 = Quantity
ValueNeeded pDecimal        
ValueFinished pDecimal        
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id bigint        
ActType tinyint 1     0 = Manual, 1 = Generated, 2 = Virtual
ActStatus tinyint 1     0 = Default, 1 = Unassigned, 2 = Completed, 3 = On Hold, 4 = User Locked, 5 = System Locked, 6 = Excluded
ConflictType int       0 = None Not Started, 1 = None Started, 2 = None Partial Complete, 3 = None Completed, 4 = On Hold, 5 = Downtime, 6 = After Hours, 7 = Late, 8 = Capacity Exceeded, 9 = Material Constraint, 10 = None Excluded
ResType tinyint 1     0 = None, 1 = Customer, 2 = Vendor, 3 = Employee, 4 = Technician, 5 = Labor Type, 6 = Machine Group, 7 = Work Center, 8 = Operation
ResourceId nvarchar 255      
ResDetailId bigint        
LocId pLocID 10      
SrcType tinyint 1     1 = Production Order,
SourceRef nvarchar 255      
ParentRef nvarchar 255      
SourceSeq bigint        
EntryNumber tinyint 1      
Quantity pDecimal 13      
OverlapYn bit 1      
MinProcessTime bigint        
MaxProcessTime bigint        
StartDate datetime 8      
EndDate datetime 8      
ExpEndDate datetime 8      
ExpMatlDate datetime 8      
Priority int 4      
SourceID1 nvarchar 255      
SourceID2 nvarchar 255      
SourceID3 nvarchar 255      
SourceID4 nvarchar 255      
SrcDocInfo1 nvarchar 255      
SrcDocInfo2 nvarchar 255      
SrcDocInfo3 nvarchar 255      
UID pUserId        
HostId pWrkStnId        
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id bigint        
ResType tinyint 1     0 = None, 1 = Customer, 2 = Vendor, 3 = Employee, 4 = Technician, 5 = Labor Type, 6 = Machine Group, 7 = Work Center, 8 = Operation
ResourceId nvarchar 255      
ResDetailId bigint        
LocId pLocID 10      
LineNumber bigint        
ScheduleId nvarchar 10      
AvailType tinyint 1     0 = Available, 1 = Unavailable
StartDate datetime 8      
EndDate datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id bigint        
ResType tinyint 1     0 = None, 1 = Customer, 2 = Vendor, 3 = Employee, 4 = Technician, 5 = Labor Type, 6 = Machine Group, 7 = Work Center, 8 = Operation
ResourceId nvarchar 255      
LocId pLocID 10      
LineNumber bigint        
ResStatus tinyint 1     0 = Active, 1 = Inactive, 2 = Excluded (not included on the schedule)
Description pDescription 255      
EfficiencyPct pDecimal 13 100    
ScheduleId nvarchar 10      
ExtAttribute bigint     Resource-specific attributes  
ExtInfo nvarchar max   Resource-specific extended information  
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id bigint        
HeaderId bigint        
AvailType tinyint 1     0 = Available, 1 = Unavailable
StartDate datetime 8      
EndDate datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id bigint        
ScheduleId nvarchar 10      
EntryDate datetime 8      
StartDate datetime 8      
EndDate datetime 8      
CF xml -1      
ts timestamp 8